using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.Odbc;
using DTO;
namespace DAO
{
    public class SachDAO
    {
        DataProvider _provider = new DataProvider();
        public SachDAO()
        {
            _provider.connect();
        }
        public DataTable GetTablbeSach()
        {
            String stringSqlQrery = "Select * from Sach";
            OdbcDataAdapter da = _provider.OdbcAdapter(stringSqlQrery);
            DataSet ds = new DataSet();
            da.Fill(ds);
            _provider.disconnect();
            return ds.Tables[0];
        }
    }
}
